package com.gla.dao;

import com.gla.domain.Evaluation;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface EvaluationMapper {

    @Select("SELECT * FROM EVALUATION WHERE id=#{id}")
    public Evaluation getEvaluationById(Integer id);

    @Insert("INSERT INTO EVALUATION (evaluation,point,user_id,commodity_id,shop_id) values(#{evaluation},#{point},#{user_id},#{commodity},#{shop_id})")
    public void add(Evaluation evaluation);
}
